package top.zlhy7.module.work.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import top.zlhy7.module.work.entity.WordOrder;
import top.zlhy7.module.work.vo.WorkOrderStatistics1Vo;
import top.zlhy7.module.work.vo.WorkOrderStatistics2Vo;
import top.zlhy7.module.work.vo.WorkOrderStatistics3Vo;

import java.util.List;

/**
 * @author renyong
 * @date 2024/9/29 19:34
 * @description 工单 持久层
 */
@Mapper
public interface WordOrderMapper extends BaseMapper<WordOrder> {
    /**
     * 工单统计1: 查询7月每天的工单总量、超期率，超期率=超期工单总量/工单总量
     * @param query
     * @return
     * @author renyong on 2024/9/30 01:29
     */
    List<WorkOrderStatistics1Vo> statistics1(WorkOrderStatistics1Vo query);
    /**
     * 工单统计2：查询7月每个部门的工单总量、超期率。
     * @param query
     * @return
     * @author renyong on 2024/9/30 01:29
     */
    List<WorkOrderStatistics2Vo> statistics2(WorkOrderStatistics2Vo query);
    /**
     * 工单统计3：查询7月每个工单类型的工单总量、超期率。
     * @param query
     * @return
     * @author renyong on 2024/9/30 01:29
     */
    List<WorkOrderStatistics3Vo> statistics3(WorkOrderStatistics3Vo query);
}
